select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%SiNan Masion%' or b.enpropertyname like '%SiNan Masion%') order by updateTime Desc, a.dftpic desc
Sinan Masion super nice compound in the heart of Shanghai,walking distance to Xintiandi and IAPM.Good neighbourhood with a lot of Western style restaurant ,bars...
4bedrooms with 3bathrooms, large size livignrooms space,high quality eqipements in the kitchen, parts of furnished, can be negotiable about the furniture
THe apt now is unfurnished, conditionis very great, the current tenant will move out by end of Oct. 3Bedrooms with totally 160sqm , large size balcony and brigh...